* regressions_formal_employment_industry.do	JEP	04/29/15
* Does regressions for industry employment
* Monthly wages
* Exclude some industries
* Do regressions by city - industry
* Do not use city level employment as regressor, clearly endogenous.

*************************** Change log ********************************** 

/*
	
*/	

clear 
version 13.1

* Project info
cap project, doinfo
if _rc==198 {
	if c(os)=="Unix" loc master "/home/jperez/AA_Minimum_Wage" 
else if c(username)=="J16339" | c(username)=="A15858" loc master "B:\Col_Minimum_Wage" 
	else loc master "C:/Users/jorpp/Dropbox (Brown)/Col_Minimum_Wage"
 loc pr = 0
}
else {
	local master "`r(pdir)'"
	local doname "`r(dofile)'"  
 loc pr = 1
	* Project calls
	project, uses("`master'/Data/Source/ocupados_mw.dta")
	project, uses("`master'/Data/Source/empvars_informal_edom.dta")
	* Call programs
	project, relies_on("`master'/Code/Est/sample_choice.do")
	project, relies_on("`master'/Code/Est/build_mw_measures.do")
	project, relies_on("`master'/Code/Est/build_treatment.do")
	project, relies_on("`master'/Code/Est/export_ols.do")
	project, relies_on("`master'/Code/Est/confirmedrunols.do")	
}
*/

* di 84
* Call necessary programs. I do not call using project to carry the programs around. I do not put these in the ado/personal folder because they are specific to the project. They are not ado files.
do "`master'/Code/Est/sample_choice.do"
do "`master'/Code/Est/build_mw_measures_defl_nac.do"
do "`master'/Code/Est/build_treatment.do"
do "`master'/Code/Est/export_ols.do"
do "`master'/Code/Est/confirmedrunols.do"


use "`master'/Data/Source/ocupados_mw_alt.dta", clear

* Number of bootstraps
glo boot=500
*
* Choose sample
mysample h4sample , hmin(30) hmax(50) sex(0) edadm(65) wage(salario)formal exind(13,29,42)
* Build mw measures
mw_measures h4sample , stub(h4)
* Build treatment
mytreatment, posts("tq(1999q1)") mw(mw_to_medw_h4) wage(salario_mensual_real_p)

* RIF regressions

* Create estimation results folder if it doesn't already exist
cap mkdir "`master'/Ster"
cap mkdir "`master'/Ster/h4_new_med_indcc_nce_defl_nac"

* For these I'm going to assume the clusters are the city - industry pairs. This assumes that there is not correlation within city across industries, only within those pairs. Could also run with the standard clustering by city, but that would mean that I'm not really increasing the sample size by running within industry.

* The number of clusters is  enough that I don't need the full CGM framework, can run just with cluster
egen city_ind=group(ccode cactividad_empresa)
if `pr'!=0 loc reg="register"
else loc reg ""

* Notice differences with rifs. Only one table for all specs, therefore only one name. First goes with replace, others with append.


loc name "`master'/Ster/h4_new_med_indcc_nce_defl_nac/reg_tq(1999q1)_bite_horas_50_edom_indcc_nce"

* Panel A. Employment
* confirmedrunols, `reg' y(horas_semana) controls() name(`name') ctitle(emp) ster(`master'/Ster/h4_new_med_indcc_nce_defl_nac/reg_tq(1999q1)_bite_horas_50_edom_indcc_nce) rif(h4A)  r(replace)  fe(i.ccode#i.cactividad_empresa i.time) cluster(ccode) sample(h4sample) rerun
* Panel B. Employment and Bartik Price Variable
confirmedrunols, `reg' y(horas_semana) controls(bartikp1_ex_p) name(`name') ctitle(emp_bp) ster(`master'/Ster/h4_new_med_indcc_nce_defl_nac/reg_bp_tq(1999q1)_bite_horas_50_edom_indcc_nce) rif(h4B)  r(replace)  fe(i.ccode#i.cactividad_empresa i.time) cluster(ccode) sample(h4sample)  rerun
* Panel C. Employment and Bartik Quantity Variable 
*confirmedrunols, `reg' y(horas_semana) controls(bartikq_ex) name(`name') ctitle(emp_bq) ster(`master'/Ster/h4_new_med_indcc_nce_defl_nac/reg_bq_tq(1999q1)_bite_horas_50_edom_indcc_nce) rif(h4C)  r(append)  fe(i.ccode#i.cactividad_empresa i.time) cluster(ccode) sample(h4sample)  rerun
* Panel D. Employment and City Trends
*confirmedrunols, `reg' y(horas_semana) controls(i.ccode#c.trend ) name(`name') ctitle(sst_emp) ster(`master'/Ster/h4_new_med_indcc_nce_defl_nac/reg_sst_emp_tq(1999q1)_bite_horas_50_edom_indcc_nce) rif(h4D)  r(append)  fe(i.ccode#i.cactividad_empresa i.time) cluster(ccode) sample(h4sample) rerun
* Panel E. Employment, Bartik Price Variable and City Trends
confirmedrunols, `reg' y(horas_semana) controls(i.ccode#c.trend bartikp1_ex_p) name(`name') ctitle(sst_emp_bp) ster(`master'/Ster/h4_new_med_indcc_nce_defl_nac/reg_sst_emp_bp_tq(1999q1)_bite_horas_50_edom_indcc_nce) rif(h4E)  r(append)  fe(i.ccode#i.cactividad_empresa i.time) cluster(ccode) sample(h4sample) rerun
* Panel F. Employment, Bartik Quantity Variable and City Trends
*confirmedrunols, `reg' y(horas_semana) controls(i.ccode#c.trend bartikq_ex) name(`name') ctitle(sst_emp_bq) ster(`master'/Ster/h4_new_med_indcc_nce_defl_nac/reg_sst_emp_bq_tq(1999q1)_bite_horas_50_edom_indcc_nce) rif(h4F)  r(append)  fe(i.ccode#i.cactividad_empresa i.time) cluster(ccode) sample(h4sample)  rerun
* Panel G. Employment, Bartik Price Variable - Industry fe, city fe and interactions
*confirmedrunols, `reg' y(horas_semana) controls(bartikp1_ex_p) name(`name') ctitle(emp_bp_ixc) ster(`master'/Ster/h4_new_med_indcc_nce_defl_nac/reg_bp_ixc_tq(1999q1)_bite_horas_50_edom_indcc_nce) rif(h4G)  r(append)  fe(i.ccode##i.cactividad_empresa i.time) cluster(ccode) sample(h4sample) rerun
* Panel H. Employment, Bartik Quantity Variable and City - Industry fe, city fe and interactions
*confirmedrunols, `reg' y(horas_semana) controls(bartikq_ex) name(`name') ctitle(emp_bq_ixc) ster(`master'/Ster/h4_new_med_indcc_nce_defl_nac/reg_bq_ixc_tq(1999q1)_bite_horas_50_edom_indcc_nce) rif(h4H)  r(append)  fe(i.ccode##i.cactividad_empresa i.time) cluster(ccode) sample(h4sample) rerun
* Panel I - Employment, Bartik Price Variable - Industry fe, city fe and interactions - City Industry trends
*confirmedrunols, `reg' y(horas_semana) controls(bartikp1_ex_p) name(`name') ctitle(ct_emp_bp_ixc) ster(`master'/Ster/h4_new_med_indcc_nce_defl_nac/reg_ct_emp_bp_ixc_tq(1999q1)_bite_horas_50_edom_indcc_nce) rif(h4I)  r(append)  fe(i.ccode##i.cactividad_empresa i.ccode#i.cactividad_empresa#c.trend i.time) cluster(ccode) sample(h4sample)  rerun	
* Panel J. Employment, Bartik Quantity Variable and City - Industry fe, city fe and interactions
*confirmedrunols, `reg' y(horas_semana) controls(bartikq_ex) name(`name') ctitle(ct_emp_bq_ixc) ster(`master'/Ster/h4_new_med_indcc_nce_defl_nac/reg_ct_emp_bq_ixc_tq(1999q1)_bite_horas_50_edom_indcc_nce) rif(h4J)  r(append)  fe(i.ccode##i.cactividad_empresa i.ccode#i.cactividad_empresa#c.trend i.time) cluster(ccode) sample(h4sample) rerun
* Panel L. Employment, Bartik Price Variable and City Trends and Industry Trends
confirmedrunols, `reg' y(horas_semana) controls(bartikp1_ex_p i.ccode#c.trend i.cactividad_empresa#c.trend) name(`name') ctitle(itct) ster(`master'/Ster/h4_new_med_indcc_nce_defl_nac/reg_itct_bp_tq(1999q1)_bite_horas_50_edom_indcc_nce) rif(h4L) r(append)  fe(i.ccode#i.cactividad_empresa i.time) cluster(ccode) sample(h4sample) rerun
